2016-08-22 - 27363 - Spec - Inventory WEBI #WEBI
SPECIFICATIONS
27363 - Inventory WEBI
Requirement Summary
Need to create WEBI based on the New Inventory cube for data extraction.
Admin Info
Purpose
|
Wrong Factory Calendar assigned to routes
|
Requested By
|
Jayson Osmars
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
08/22/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZIC_MP05_Q001_DUMP
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
00
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity/validation
|
04
|
|
TOTAL
|
32
|
References
Prior Tickets
27363.100
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
Provided report output format .CSV file
|
Jayson
|
08/24/2016
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create a WEBI based on the New Inventory cube for data extraction.
In Scope:
Materials having stock for current period.
Out of Scope:
Materials not having stock for current period.
Solution Summary
1. Need to create WEBI report based below details:
Objects for Inventory Extraction:
- Material ID
- Material Description
- Category
- Collection
- SBU
- Gender
- Logo
- Material Group
- Year
- Plant
- PMS Color
- Sales Org
- Season
- Season Grouping
- First Planned Ship Date
- Last Planned Ship Date
- Last Consumption Date
- Last Receipt Date
- Silhouette
- Sport
- Company Code
- Material Category
- Gridvalue
- Total Qty
- Total Value
These are the required plants for data extraction:
US Headwear
0110
8010
0116
0117
0145
US Apparel
1410
1420
1416
7410
Canada
0210
0215
Mexico
0280
2. Need to add the logic in the report for getting required output as shown below:
0MATERIAL_0MATL_TYPE = FERT
Stock Qty <> 0
3. Need to pass the values to parameters in the report.
4. The report output format is CSV
5. Need to validate the data with BEx query.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC standard checklist.
|
2
|
Execute WEBI Report in WEBI Designer tool after changes.
|
Report should execute successfully in WEBI Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Created the WEBI report based on the available fields for data extraction.
2. Add the logic in the report for getting required output as shown below:
0MATERIAL_0MATL_TYPE = FERT
Stock Qty <> 0
3. Passed the values to parameters in the report.
4. The report output format is CSV
5. Validated the data with BEx query.
Issues
The below fields are not available in the inventory cube and hence not included in the data extract:
1. Customer
2. Customer Segment
3. Silhouette Consolidation ID
4. SBU Consolidation ID